pp108 : GetAllDSOs (Deprecated)

GetAllDSOs (Deprecated)

 


This Web service operation returns the database configurations available in an organization.

SOAP Request

<GetAllDSOs xmlns="http://schemas.cordys.com/DSOConfig/1.0"/>

SOAP Response

 <GetAllDSOsResponse xmlns:SOAP="http://schemas.xmlsoap.org/soap/envelope/" xmlns="http://schemas.cordys.com/DSOConfig/1.0">
     <datasources>
       <dso>
         <name>Cordys System#system</name>
         <type>Relational</type>
         <description>Database Configuration for running Cordys</description>
         <organization>system</organization>
         <configuration>
           <component name="Connection pool" dsocategory="system">
             <provider>SQLOLEDB</provider>
             <driverName>OLEDB</driverName>
             <defaultDatabase>CORDYS_DB_443</defaultDatabase>
             <server>TestServer</server>
             <userName>username</userName>
             <password>pwd</password>
           </component>
         </configuration>
       </dso>
       <dso>
         <name>Cordys Logger#system</name>
         <type>Relational</type>
         <description>Database Configuration used by Composite Application</description>
         <organization>system</organization>
         <configuration>
           <component name="Connection pool">
             <jdbcDriver>net.sourceforge.jtds.jdbc.Driver</jdbcDriver>
             <driverName>JDBC</driverName>
             <jdbcDriverXAClass />
             <defaultDatabase>CORDYS_DB_443</defaultDatabase>
             <connectionString>
               <![CDATA[jdbc:jtds:sqlserver://Testserver/CORDYS_DB_443]]>
             </connectionString>
              <userName>username</userName>
             <password>pwd</password>
           </component>
         </configuration>
       </dso>       
     </datasources>
   </GetAllDSOsResponse>

Response Parameters

Parameter

Description

Data Type

Accepted Input Values

name

Name of the database configuration

String

-

type

Indicates the type of database configuration

String

Relational

description

Description of the database configuration

String

-

configuration

Indicates the configuration details of the database

 

 

  • provider
  • driverName - OLEDB or JDBC
  • defaultDatabase
  • server
  • userName
  • password

organization

Specifies the organization where the database configurations are created.

String

-